Each data entity in the master data repository must be able to maintain some MDM specific information. For each data entity in the master data repository, it is required to add seven MDM specific additional columns. You can create these scripts in either of the following ways:

• Execute the scripts
• Create the scripts manually.

1. Do the following to execute the scripts to create the columns:
   The utility stored procedure creation script, available at <<Cordys_HOME>>\components\mdm\dbscripts\applicationlocation, can be used to add these columns to the given tables.
   1. Open a database client tool, based on the database used for MDM hub application database configuration.
   2. Go to the file system location <<Cordys_HOME>>\components\mdm\dbscripts\application and choose the appropriate .sql file.
   3. Execute the .sql script from the tool. This step will create a new Stored Procedure ADDMDMHUBFIELDS to the database.
   4. Execute the newly created stored procedure with comma separated table name(s) as input.

      For example: If your master data repository is using MS SQL server, then:

      1. Connect to MS SQL server using SQL server client.
      2. Connect to the corresponding database.
      3. Run the scripts in components\mdm\dbscripts\application\MDM_SQLSERVER_UTILSCRIPTS.sql. This will create ADDMDMHUBFIELDS procedure in the selected database.
      4. Execute the stored procedure using EXEC ADDMDMHUBFIELDS 'TABLE1,TABLE2' where TABLE1 and TABLE2 are the table names in the database in which you want to add the MDM specific fields.
2. Do the following to manually create the columns.
   Based on the database used, do the following in the table schema:
   1. Oracle Database
      If you are using an Oracle database as the master database, create the following columns in the database:

      Field	Datatype	Length	Null Option
      RCORGUID	VARCHAR2	50	NULL
      RCORDELETED	NUMBER	1	NULL
      RCOROWNER	VARCHAR2	1000	NULL
      RCORLASTMODIFIED	DATE		NULL
      RCOREXPIRY	DATE		NULL
      RCORLASTMODIFIEDBY	VARCHAR2	50	NULL
      RCOROPERATION	NUMBER	1	NULL

   2. MS SQL Database
      If you are using an MSSQL database as the master database, create the following columns in the database:

      Field	Datatype	Length	Null Option
      RCORGUID	VARCHAR	50	NULL
      RCORDELETED	INT		NULL
      RCOROWNER	NVARCHAR	1000	NULL
      RCORLASTMODIFIED	DATETIME		NULL
      RCOREXPIRY	DATETIME		NULL
      RCORLASTMODIFIEDBY	NVARCHAR	50	NULL
      RCOROPERATION	INT		NULL

   3. DB2 Database
      If you are using an DB2 database as the master database, create the following columns in the database:

      Field	Datatype	Length	Null Option
      RCORGUID	VARCHAR	50	NULL
      RCORDELETED	INT		NULL
      RCOROWNER	NVARCHAR	1000	NULL
      RCORLASTMODIFIED	TIMESTAMP		NULL
      RCOREXPIRY	TIMESTAMP		NULL
      RCORLASTMODIFIEDBY	NVARCHAR	50	NULL
      RCOROPERATION	INT		NULL

   4. MySQL Database
      If you are using an MySQL database as the master database, create the following columns in the database:

      Field	Datatype	Length	Null Option
      RCORGUID	VARCHAR	50	NULL
      RCORDELETED	INT		NULL
      RCOROWNER	VARCHAR	1000	NULL
      RCORLASTMODIFIED	DATETIME		NULL
      RCOREXPIRY	DATETIME		NULL
      RCORLASTMODIFIEDBY	VARCHAR	50	NULL
      RCOROPERATION	INT		NULL